<?php
/*
 *   This file is part of poat.
 *
 *   poat is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   poat is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU General Public License for more details.
 *
 *   You should have received a copy of the GNU General Public License
 *   along with poat.  If not, see <http://www.gnu.org/licenses/>.
 *   
 *   Copyright (c) 2008 Sergio Gabriel Teves <gabriel.sgt at gmail.com>
 * */
 
global $db;
global $loader;

$fpos = strrpos(dirname(__FILE__), "/");
if ($fpos<=0) {
	$fpos = strrpos(dirname(__FILE__), "\\");
}

define('ROOT_PATH',substr(dirname(__FILE__), 0, $fpos)."/");

require_once(ROOT_PATH."configs/config.php");
include_once(ROOT_PATH."configs/dbconf.php");
require_once(ROOT_PATH."includes/log.php");
require_once(ROOT_PATH."includes/util.func.php");
require_once(ROOT_PATH."func/functions.inc.php");
require_once(ROOT_PATH."class/dbmanager.class.php");
require_once(ROOT_PATH."class/loader.class.php");

require_once(ROOT_PATH."class/project.class.php");

$db = new dbmanager(DB_HOST,DB_USER,DB_PASS);

$db->connect(DB_NAME);
$loader = new loader($db);

$project = new project;
$list = $loader->loadList($project);

foreach ($list as $prj) {
	$query = "ALTER TABLE ".FILES.PROJECT_PREFIX.$prj->id." ADD COLUMN autoflag TINYINT(4) NOT NULL DEFAULT 0";
	$db->execute($query);	
	echo FILES.PROJECT_PREFIX.$prj->id." - ".$db->error."<br>";
}

$db->close();
  
?>
